Skip to main content

常用表结构修改语句

修改列名​

例：将SYS_Member的Openid更名为OpenId

EXEC sp_rename 'SYS_Member.Openid','OpenId'

修改类型​

ALTER TABLE SYS_Member ALTER COLUMN field1_nvchar nvarchar(256) not null

创建新表​

CREATE TABLE [dbo].[SYS_Member](
    [Openid] [nvarchar](64),
    [Unionid] [nvarchar](64),
    [SessionKey] [nvarchar](64),
    [NickName] [nvarchar](64),
    [Avatar] [nvarchar](256),
    [MobilePhone] [nvarchar](16),
    [UID] [uniqueidentifier] not null primary key,
    [Index] [int],
    [LastModifyUserUID] [uniqueidentifier],
    [LastModifyDate] [datetime],
    [Status] [int],
    [CreateDate] [datetime],
    [CreatorUID] [uniqueidentifier],
    [Comment] [nvarchar](500),
);

删除表​

DROP TABLE SYS_TemplateCatelog;